shoot (yourself) in the foot

Translations
se tirer une balle dans le pied
Definitions
To unintentionally make a situation worse for yourself, often by making a mistake or poor decision that harms your own interests.